SDAC

TMSConnectionOptions Properties

Properties of the TMSConnectionOptions class.

For a complete list of the TMSConnectionOptions class members, see the TMSConnectionOptions Members topic.

Public

Name Description

DefaultSortType (inherited from TDAConnectionOptions)

Specifies the default type of local sorting for string fields. It is used when a sort type is not explicitly set after the field name in the TMemDataSet.IndexFieldNames property of a dataset.

DisconnectedMode (inherited from TDAConnectionOptions)

Opens a connection only when needed to perform a server call, and closes that connection after the operation is complete.

KeepDesignConnected (inherited from TDAConnectionOptions)

Prevents an application from establishing a connection at the time of startup.

LocalFailover (inherited from TDAConnectionOptions)

If True, the TCustomDAConnection.OnConnectionLost event occurs, and a failover operation can be performed after the connection is lost.

NumericType (inherited from TCustomMSConnectionOptions)

Specifies the format of storing and representing the NUMERIC (DECIMAL) fields for all TCustomMSDataSets associated with the given connection.

QuotedIdentifier (inherited from TCustomMSConnectionOptions)

Causes Microsoft SQL Server to follow the SQL-92 rules for delimiting identifiers and literal strings with quotation marks.

UseWideMemos (inherited from TCustomMSConnectionOptions)

Manages field type creation for the NTEXT data type.

Published

Name Description

AccessToken

Specifies the access token used for authentication in Azure Active Directory. Supported only by the prMSOLEDB provider (Microsoft OLE DB Driver for SQL Server).

AllowImplicitConnect (inherited from TDAConnectionOptions)

Specifies whether to allow or not implicit connection opening.

ApplicationIntent

Specifies the application workload type when connecting to a server.

ApplicationName

Specifies the name of a client application. The default value is the name of the executable file of your application.

AutoTranslate

Enables the translation of character strings sent between the client and server by utilizing Unicode conversion.

Charset

Specifies the character set applied when writing string parameter values in the national encoding format.

DefaultLockTimeout

Specifies the time, in milliseconds, that a transaction will wait to acquire a lock.

Encrypt

Specifies whether to encrypt data before sending it over the network.

FailoverPartner

Specifies the SQL Server name to which the SQL Native Client will reconnect when a failover of the principal SQL Server occurs.

ForceCreateDatabase

Forces the TMSConnection to create a new database prior to opening a connection in cases where the database doesn't exist.

InitialFileName

Specifies the name of the main database file.

IPVersion

Specifies the version of the Internet Protocol. The default value is ivIPv4.

Language

Specifies the SQL Server language name.

MSOLEDBVersion

Specifies the version of the Microsoft OLE DB Driver.

MultipleActiveResultSets

Enables support for the Multiple Active Result Sets (MARS) technology.

MultipleConnections

Enables and disables the creation of additional connections to support concurrent sessions, commands, and row-set objects.

NativeClientVersion

Specifies which version of the SQL Native Client will be used.

NetworkLibrary

Specifies the name of the Net-Library (DLL) used to communicate with an instance of the SQL Server.

PacketSize

Specifies the size of the network packet (in bytes).

PersistSecurityInfo

Enables the data source object to persist sensitive authentication information, such as a password, along with other authentication information.

Provider

Specifies a provider from the list of supported providers.

TrustServerCertificate

Enables traffic encryption without validation.

UuidWithBraces

Specifies whether curly braces should be added to GUID values of the uniqueidentifier field type. This option is Boolean. The default value is True.

WorkstationID

Specifies a string identifying the workstation.

See Also

© 1997-2025 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback